Overview

Dataset statistics

Number of variables31
Number of observations100
Missing cells993
Missing cells (%)32.0%
Duplicate rows0
Duplicate rows (%)0.0%
Total size in memory23.7 KiB
Average record size in memory242.3 B

Variable types

NUM24
CAT5
BOOL1
DATE1

Reproduction

Analysis started2020-08-07 14:04:27.012286
Analysis finished2020-08-07 14:05:17.844453
Duration50.83 seconds
Versionpandas-profiling v2.8.0
Command linepandas_profiling --config_file config.yaml [YOUR_FILE.csv]
Download configurationconfig.yaml

Warnings

COUNTRY_REGION has constant value "United States" Constant
ISO3166_1 has constant value "US" Constant
LAST_UPDATED_DATE has constant value "2020-08-07 12:04:04.675800" Constant
LAST_REPORTED_FLAG has constant value "False" Constant
DATE has a high cardinality: 68 distinct values High cardinality
DEATH is highly correlated with POSITIVE and 1 other fieldsHigh correlation
POSITIVE is highly correlated with DEATH and 3 other fieldsHigh correlation
HOSPITALIZED is highly correlated with POSITIVE and 3 other fieldsHigh correlation
TOTAL is highly correlated with NEGATIVE and 1 other fieldsHigh correlation
NEGATIVE is highly correlated with TOTAL and 1 other fieldsHigh correlation
TOTAL_SINCE_PREVIOUS_DAY is highly correlated with NEGATIVE_SINCE_PREVIOUS_DAYHigh correlation
NEGATIVE_SINCE_PREVIOUS_DAY is highly correlated with TOTAL_SINCE_PREVIOUS_DAYHigh correlation
HOSPITALIZEDCUMULATIVE is highly correlated with POSITIVE and 3 other fieldsHigh correlation
HOSPITALIZEDCUMULATIVEINCREASE is highly correlated with HOSPITALIZED_SINCE_PREVIOUS_DAY and 2 other fieldsHigh correlation
HOSPITALIZED_SINCE_PREVIOUS_DAY is highly correlated with HOSPITALIZEDCUMULATIVEINCREASEHigh correlation
INICUCURRENTLY is highly correlated with HOSPITALIZEDCURRENTLY and 3 other fieldsHigh correlation
HOSPITALIZEDCURRENTLY is highly correlated with INICUCURRENTLY and 2 other fieldsHigh correlation
INICUCUMULATIVE is highly correlated with POSITIVE and 9 other fieldsHigh correlation
INICUCUMULATIVEINCREASE is highly correlated with DEATH_SINCE_PREVIOUS_DAYHigh correlation
DEATH_SINCE_PREVIOUS_DAY is highly correlated with INICUCUMULATIVEINCREASEHigh correlation
ONVENTILATORCURRENTLY is highly correlated with HOSPITALIZED and 6 other fieldsHigh correlation
ONVENTILATORCUMULATIVE is highly correlated with INICUCUMULATIVE and 1 other fieldsHigh correlation
NEGATIVE has 4 (4.0%) missing values Missing
PENDING has 88 (88.0%) missing values Missing
PENDING_SINCE_PREVIOUS_DAY has 88 (88.0%) missing values Missing
DEATH has 9 (9.0%) missing values Missing
HOSPITALIZED has 45 (45.0%) missing values Missing
HOSPITALIZEDCURRENTLY has 28 (28.0%) missing values Missing
HOSPITALIZEDCURRENTLYINCREASE has 28 (28.0%) missing values Missing
HOSPITALIZEDCUMULATIVE has 45 (45.0%) missing values Missing
HOSPITALIZEDCUMULATIVEINCREASE has 45 (45.0%) missing values Missing
INICUCURRENTLY has 59 (59.0%) missing values Missing
INICUCURRENTLYINCREASE has 60 (60.0%) missing values Missing
INICUCUMULATIVE has 89 (89.0%) missing values Missing
INICUCUMULATIVEINCREASE has 89 (89.0%) missing values Missing
ONVENTILATORCURRENTLY has 64 (64.0%) missing values Missing
ONVENTILATORCURRENTLYINCREASE has 64 (64.0%) missing values Missing
ONVENTILATORCUMULATIVE has 94 (94.0%) missing values Missing
ONVENTILATORCUMULATIVEINCREASE has 94 (94.0%) missing values Missing
TOTAL has unique values Unique
POSITIVE has 3 (3.0%) zeros Zeros
POSITIVE_SINCE_PREVIOUS_DAY has 11 (11.0%) zeros Zeros
NEGATIVE_SINCE_PREVIOUS_DAY has 14 (14.0%) zeros Zeros
PENDING_SINCE_PREVIOUS_DAY has 2 (2.0%) zeros Zeros
DEATH has 5 (5.0%) zeros Zeros
DEATH_SINCE_PREVIOUS_DAY has 33 (33.0%) zeros Zeros
HOSPITALIZED_SINCE_PREVIOUS_DAY has 54 (54.0%) zeros Zeros
TOTAL_SINCE_PREVIOUS_DAY has 5 (5.0%) zeros Zeros
HOSPITALIZEDCURRENTLYINCREASE has 7 (7.0%) zeros Zeros
HOSPITALIZEDCUMULATIVEINCREASE has 9 (9.0%) zeros Zeros
INICUCURRENTLYINCREASE has 7 (7.0%) zeros Zeros
INICUCUMULATIVEINCREASE has 2 (2.0%) zeros Zeros
ONVENTILATORCURRENTLYINCREASE has 8 (8.0%) zeros Zeros

Variables

COUNTRY_REGION
Categorical

CONSTANT
REJECTED

Distinct count1
Unique (%)1.0%
Missing0
Missing (%)0.0%
Memory size800.0 B
United States
100
ValueCountFrequency (%) 
United States100100.0%
 

Length

Max length13
Median length13
Mean length13
Min length13

PROVINCE_STATE
Categorical

Distinct count47
Unique (%)47.0%
Missing0
Missing (%)0.0%
Memory size800.0 B
Pennsylvania
 
5
Connecticut
 
4
Massachusetts
 
3
Nebraska
 
3
California
 
3
Other values (42)
82
ValueCountFrequency (%) 
Pennsylvania55.0%
 
Connecticut44.0%
 
Massachusetts33.0%
 
Nebraska33.0%
 
California33.0%
 
Michigan33.0%
 
Wyoming33.0%
 
Colorado33.0%
 
Texas33.0%
 
Montana33.0%
 
Other values (37)6767.0%
 

Length

Max length24
Median length8
Mean length9
Min length4

DATE
Categorical

HIGH CARDINALITY

Distinct count68
Unique (%)68.0%
Missing0
Missing (%)0.0%
Memory size800.0 B
2020-07-07
 
4
2020-07-13
 
4
2020-06-19
 
3
2020-07-29
 
3
2020-04-14
 
2
Other values (63)
84
ValueCountFrequency (%) 
2020-07-0744.0%
 
2020-07-1344.0%
 
2020-06-1933.0%
 
2020-07-2933.0%
 
2020-04-1422.0%
 
2020-05-1322.0%
 
2020-07-2422.0%
 
2020-06-1522.0%
 
2020-06-0222.0%
 
2020-05-2722.0%
 
Other values (58)7474.0%
 

Length

Max length10
Median length10
Mean length10
Min length10

POSITIVE
Real number (ℝ≥0)

HIGH CORRELATION
ZEROS

Distinct count96
Unique (%)96.0%
Missing0
Missing (%)0.0%
Infinite0
Infinite (%)0.0%
Mean35648.86
Minimum0
Maximum337055
Zeros3
Zeros (%)3.0%
Memory size800.0 B

Quantile statistics

Minimum0
5-th percentile3
Q11686.5
median10757.5
Q351549.5
95-th percentile132334.15
Maximum337055
Range337055
Interquartile range (IQR)49863

Descriptive statistics

Standard deviation54318.9712
Coefficient of variation (CV)1.523722531
Kurtosis9.592730881
Mean35648.86
Median Absolute Deviation (MAD)10731.5
Skewness2.639803812
Sum3564886
Variance2950550633
Histogram with fixed size bins (bins=10)
ValueCountFrequency (%) 
033.0%
 
322.0%
 
13322.0%
 
8897011.0%
 
374311.0%
 
1462411.0%
 
13059311.0%
 
710511.0%
 
106011.0%
 
178711.0%
 
Other values (86)8686.0%
 
ValueCountFrequency (%) 
033.0%
 
111.0%
 
322.0%
 
511.0%
 
1011.0%
 
ValueCountFrequency (%) 
33705511.0%
 
19557111.0%
 
17678311.0%
 
17303311.0%
 
16541611.0%
 

POSITIVE_SINCE_PREVIOUS_DAY
Real number (ℝ)

ZEROS

Distinct count86
Unique (%)86.0%
Missing0
Missing (%)0.0%
Infinite0
Infinite (%)0.0%
Mean604.91
Minimum-31
Maximum5349
Zeros11
Zeros (%)11.0%
Memory size800.0 B

Quantile statistics

Minimum-31
5-th percentile0
Q138.5
median198.5
Q3831.25
95-th percentile2193.85
Maximum5349
Range5380
Interquartile range (IQR)792.75

Descriptive statistics

Standard deviation979.2991319
Coefficient of variation (CV)1.618917082
Kurtosis9.252611575
Mean604.91
Median Absolute Deviation (MAD)196
Skewness2.856454203
Sum60491
Variance959026.7898
Histogram with fixed size bins (bins=10)
ValueCountFrequency (%) 
01111.0%
 
433.0%
 
26822.0%
 
4222.0%
 
3911.0%
 
17511.0%
 
-3111.0%
 
29011.0%
 
29111.0%
 
208411.0%
 
Other values (76)7676.0%
 
ValueCountFrequency (%) 
-3111.0%
 
01111.0%
 
111.0%
 
433.0%
 
511.0%
 
ValueCountFrequency (%) 
534911.0%
 
433311.0%
 
431711.0%
 
401411.0%
 
232411.0%
 

NEGATIVE
Real number (ℝ≥0)

HIGH CORRELATION
MISSING

Distinct count95
Unique (%)99.0%
Missing4
Missing (%)4.0%
Infinite0
Infinite (%)0.0%
Mean351568.6354166667
Minimum0.0
Maximum3498774.0
Zeros1
Zeros (%)1.0%
Memory size800.0 B

Quantile statistics

Minimum0
5-th percentile166.25
Q124835.5
median148095
Q3406865.25
95-th percentile1340490.5
Maximum3498774
Range3498774
Interquartile range (IQR)382029.75

Descriptive statistics

Standard deviation569606.7115
Coefficient of variation (CV)1.620186371
Kurtosis13.39412234
Mean351568.6354
Median Absolute Deviation (MAD)138432
Skewness3.24820474
Sum33750589
Variance3.244518057e+11
Histogram with fixed size bins (bins=10)
ValueCountFrequency (%) 
3479122.0%
 
3154611.0%
 
109599211.0%
 
14102711.0%
 
4013811.0%
 
697811.0%
 
29870511.0%
 
9980811.0%
 
18842511.0%
 
25992711.0%
 
Other values (85)8585.0%
 
(Missing)44.0%
 
ValueCountFrequency (%) 
011.0%
 
4211.0%
 
5211.0%
 
13111.0%
 
14311.0%
 
ValueCountFrequency (%) 
349877411.0%
 
299028611.0%
 
161435411.0%
 
142467511.0%
 
135541711.0%
 

NEGATIVE_SINCE_PREVIOUS_DAY
Real number (ℝ)

HIGH CORRELATION
ZEROS

Distinct count87
Unique (%)87.0%
Missing0
Missing (%)0.0%
Infinite0
Infinite (%)0.0%
Mean8167.74
Minimum-459
Maximum96097
Zeros14
Zeros (%)14.0%
Memory size800.0 B

Quantile statistics

Minimum-459
5-th percentile0
Q1253.25
median2901.5
Q38825.5
95-th percentile27909.25
Maximum96097
Range96556
Interquartile range (IQR)8572.25

Descriptive statistics

Standard deviation14538.4891
Coefficient of variation (CV)1.779989214
Kurtosis17.79345573
Mean8167.74
Median Absolute Deviation (MAD)2901.5
Skewness3.801995217
Sum816774
Variance211367665.4
Histogram with fixed size bins (bins=10)
ValueCountFrequency (%) 
01414.0%
 
55211.0%
 
2911.0%
 
1564811.0%
 
169711.0%
 
1181011.0%
 
2525111.0%
 
2525211.0%
 
2277411.0%
 
605411.0%
 
Other values (77)7777.0%
 
ValueCountFrequency (%) 
-45911.0%
 
01414.0%
 
1111.0%
 
1511.0%
 
2911.0%
 
ValueCountFrequency (%) 
9609711.0%
 
7685511.0%
 
4634611.0%
 
4048811.0%
 
4045411.0%
 

PENDING
Real number (ℝ≥0)

MISSING

Distinct count11
Unique (%)91.7%
Missing88
Missing (%)88.0%
Infinite0
Infinite (%)0.0%
Mean404.5
Minimum0.0
Maximum1242.0
Zeros1
Zeros (%)1.0%
Memory size800.0 B

Quantile statistics

Minimum0
5-th percentile0.55
Q15.5
median358.5
Q3550
95-th percentile1234.3
Maximum1242
Range1242
Interquartile range (IQR)544.5

Descriptive statistics

Standard deviation446.7918979
Coefficient of variation (CV)1.104553518
Kurtosis0.1958015094
Mean404.5
Median Absolute Deviation (MAD)320
Skewness1.045773679
Sum4854
Variance199623
Histogram with fixed size bins (bins=10)
ValueCountFrequency (%) 
55022.0%
 
7111.0%
 
30211.0%
 
122811.0%
 
611.0%
 
48511.0%
 
41511.0%
 
011.0%
 
124211.0%
 
111.0%
 
(Missing)8888.0%
 
ValueCountFrequency (%) 
011.0%
 
111.0%
 
411.0%
 
611.0%
 
7111.0%
 
ValueCountFrequency (%) 
124211.0%
 
122811.0%
 
55022.0%
 
48511.0%
 
41511.0%
 

PENDING_SINCE_PREVIOUS_DAY
Real number (ℝ)

MISSING
ZEROS

Distinct count11
Unique (%)91.7%
Missing88
Missing (%)88.0%
Infinite0
Infinite (%)0.0%
Mean8.25
Minimum-97.0
Maximum152.0
Zeros2
Zeros (%)2.0%
Memory size800.0 B

Quantile statistics

Minimum-97
5-th percentile-64.55
Q1-11.5
median0
Q331.75
95-th percentile89.3
Maximum152
Range249
Interquartile range (IQR)43.25

Descriptive statistics

Standard deviation59.23470267
Coefficient of variation (CV)7.17996396
Kurtosis3.137113892
Mean8.25
Median Absolute Deviation (MAD)33.5
Skewness0.8770551808
Sum99
Variance3508.75
Histogram with fixed size bins (bins=10)
ValueCountFrequency (%) 
022.0%
 
1911.0%
 
3011.0%
 
-9711.0%
 
15211.0%
 
3711.0%
 
-3711.0%
 
3811.0%
 
-3811.0%
 
-211.0%
 
(Missing)8888.0%
 
ValueCountFrequency (%) 
-9711.0%
 
-3811.0%
 
-3711.0%
 
-311.0%
 
-211.0%
 
ValueCountFrequency (%) 
15211.0%
 
3811.0%
 
3711.0%
 
3011.0%
 
1911.0%
 

DEATH
Real number (ℝ≥0)

HIGH CORRELATION
MISSING
ZEROS

Distinct count84
Unique (%)92.3%
Missing9
Missing (%)9.0%
Infinite0
Infinite (%)0.0%
Mean2051.7582417582416
Minimum0.0
Maximum21640.0
Zeros5
Zeros (%)5.0%
Memory size800.0 B

Quantile statistics

Minimum0
5-th percentile0.5
Q190.5
median349
Q32966
95-th percentile7050
Maximum21640
Range21640
Interquartile range (IQR)2875.5

Descriptive statistics

Standard deviation3606.081771
Coefficient of variation (CV)1.757556859
Kurtosis12.15618608
Mean2051.758242
Median Absolute Deviation (MAD)347
Skewness3.14064113
Sum186710
Variance13003825.74
Histogram with fixed size bins (bins=10)
ValueCountFrequency (%) 
055.0%
 
522.0%
 
6922.0%
 
222.0%
 
1570611.0%
 
134811.0%
 
10511.0%
 
50911.0%
 
18111.0%
 
28411.0%
 
Other values (74)7474.0%
 
(Missing)99.0%
 
ValueCountFrequency (%) 
055.0%
 
111.0%
 
222.0%
 
311.0%
 
522.0%
 
ValueCountFrequency (%) 
2164011.0%
 
1570611.0%
 
1518911.0%
 
824411.0%
 
718911.0%
 

DEATH_SINCE_PREVIOUS_DAY
Real number (ℝ≥0)

HIGH CORRELATION
ZEROS

Distinct count40
Unique (%)40.0%
Missing0
Missing (%)0.0%
Infinite0
Infinite (%)0.0%
Mean24.86
Minimum0
Maximum334
Zeros33
Zeros (%)33.0%
Memory size800.0 B

Quantile statistics

Minimum0
5-th percentile0
Q10
median5
Q325.25
95-th percentile108.05
Maximum334
Range334
Interquartile range (IQR)25.25

Descriptive statistics

Standard deviation51.93469481
Coefficient of variation (CV)2.089086678
Kurtosis17.36157431
Mean24.86
Median Absolute Deviation (MAD)5
Skewness3.807079114
Sum2486
Variance2697.212525
Histogram with fixed size bins (bins=10)
ValueCountFrequency (%) 
03333.0%
 
255.0%
 
455.0%
 
755.0%
 
933.0%
 
133.0%
 
533.0%
 
1333.0%
 
333.0%
 
822.0%
 
Other values (30)3535.0%
 
ValueCountFrequency (%) 
03333.0%
 
133.0%
 
255.0%
 
333.0%
 
455.0%
 
ValueCountFrequency (%) 
33411.0%
 
27511.0%
 
16211.0%
 
14211.0%
 
12811.0%
 

HOSPITALIZED
Real number (ℝ≥0)

HIGH CORRELATION
MISSING

Distinct count55
Unique (%)100.0%
Missing45
Missing (%)45.0%
Infinite0
Infinite (%)0.0%
Mean5433.8
Minimum1.0
Maximum84194.0
Zeros0
Zeros (%)0.0%
Memory size800.0 B

Quantile statistics

Minimum1
5-th percentile81
Q1606.5
median1644
Q36325
95-th percentile14846.5
Maximum84194
Range84193
Interquartile range (IQR)5718.5

Descriptive statistics

Standard deviation11887.22775
Coefficient of variation (CV)2.187645433
Kurtosis36.8452185
Mean5433.8
Median Absolute Deviation (MAD)1496
Skewness5.645648555
Sum298859
Variance141306183.7
Histogram with fixed size bins (bins=10)
ValueCountFrequency (%) 
872711.0%
 
1105111.0%
 
22611.0%
 
508011.0%
 
170011.0%
 
6711.0%
 
9311.0%
 
21611.0%
 
164411.0%
 
1198611.0%
 
Other values (45)4545.0%
 
(Missing)4545.0%
 
ValueCountFrequency (%) 
111.0%
 
1911.0%
 
6711.0%
 
8711.0%
 
9311.0%
 
ValueCountFrequency (%) 
8419411.0%
 
2106411.0%
 
2023311.0%
 
1253811.0%
 
1198611.0%
 

HOSPITALIZED_SINCE_PREVIOUS_DAY
Real number (ℝ≥0)

HIGH CORRELATION
ZEROS

Distinct count39
Unique (%)39.0%
Missing0
Missing (%)0.0%
Infinite0
Infinite (%)0.0%
Mean29.43
Minimum0
Maximum433
Zeros54
Zeros (%)54.0%
Memory size800.0 B

Quantile statistics

Minimum0
5-th percentile0
Q10
median0
Q336
95-th percentile151.35
Maximum433
Range433
Interquartile range (IQR)36

Descriptive statistics

Standard deviation62.83443934
Coefficient of variation (CV)2.135047208
Kurtosis17.80721109
Mean29.43
Median Absolute Deviation (MAD)0
Skewness3.67601681
Sum2943
Variance3948.166768
Histogram with fixed size bins (bins=10)
ValueCountFrequency (%) 
05454.0%
 
5433.0%
 
122.0%
 
222.0%
 
322.0%
 
1322.0%
 
2022.0%
 
3622.0%
 
6411.0%
 
1911.0%
 
Other values (29)2929.0%
 
ValueCountFrequency (%) 
05454.0%
 
122.0%
 
222.0%
 
322.0%
 
411.0%
 
ValueCountFrequency (%) 
43311.0%
 
22711.0%
 
20211.0%
 
17711.0%
 
15811.0%
 

TOTAL
Real number (ℝ≥0)

HIGH CORRELATION
UNIQUE

Distinct count100
Unique (%)100.0%
Missing0
Missing (%)0.0%
Infinite0
Infinite (%)0.0%
Mean373203.29
Minimum0
Maximum3694345
Zeros1
Zeros (%)1.0%
Memory size800.0 B

Quantile statistics

Minimum0
5-th percentile52.75
Q119537.25
median162573.5
Q3453416.5
95-th percentile1458854.45
Maximum3694345
Range3694345
Interquartile range (IQR)433879.25

Descriptive statistics

Standard deviation604448.7549
Coefficient of variation (CV)1.619623329
Kurtosis12.51687137
Mean373203.29
Median Absolute Deviation (MAD)153016
Skewness3.13165854
Sum37320329
Variance3.653582973e+11
Histogram with fixed size bins (bins=10)
ValueCountFrequency (%) 
20556611.0%
 
121687211.0%
 
75860611.0%
 
2235111.0%
 
20488011.0%
 
16187711.0%
 
83387811.0%
 
511.0%
 
44732511.0%
 
3260611.0%
 
Other values (90)9090.0%
 
ValueCountFrequency (%) 
011.0%
 
111.0%
 
311.0%
 
511.0%
 
1011.0%
 
ValueCountFrequency (%) 
369434511.0%
 
315570211.0%
 
179113711.0%
 
151530611.0%
 
150854811.0%
 

TOTAL_SINCE_PREVIOUS_DAY
Real number (ℝ)

HIGH CORRELATION
ZEROS

Distinct count93
Unique (%)93.0%
Missing0
Missing (%)0.0%
Infinite0
Infinite (%)0.0%
Mean8772.65
Minimum-459
Maximum101446
Zeros5
Zeros (%)5.0%
Memory size800.0 B

Quantile statistics

Minimum-459
5-th percentile0
Q1366
median3265.5
Q39866
95-th percentile29829.45
Maximum101446
Range101905
Interquartile range (IQR)9500

Descriptive statistics

Standard deviation15352.46697
Coefficient of variation (CV)1.750037557
Kurtosis17.62878302
Mean8772.65
Median Absolute Deviation (MAD)3252
Skewness3.777729645
Sum877265
Variance235698242.1
Histogram with fixed size bins (bins=10)
ValueCountFrequency (%) 
055.0%
 
422.0%
 
1122.0%
 
30022.0%
 
606311.0%
 
1040311.0%
 
1693511.0%
 
246911.0%
 
3911.0%
 
543311.0%
 
Other values (83)8383.0%
 
ValueCountFrequency (%) 
-45911.0%
 
055.0%
 
111.0%
 
422.0%
 
1011.0%
 
ValueCountFrequency (%) 
10144611.0%
 
8117211.0%
 
4853311.0%
 
4478711.0%
 
4053511.0%
 

ISO3166_1
Categorical

CONSTANT
REJECTED

Distinct count1
Unique (%)1.0%
Missing0
Missing (%)0.0%
Memory size800.0 B
US
100
ValueCountFrequency (%) 
US100100.0%
 

Length

Max length2
Median length2
Mean length2
Min length2

ISO3166_2
Categorical

Distinct count47
Unique (%)47.0%
Missing0
Missing (%)0.0%
Memory size800.0 B
PA
 
5
CT
 
4
UT
 
3
OR
 
3
MI
 
3
Other values (42)
82
ValueCountFrequency (%) 
PA55.0%
 
CT44.0%
 
UT33.0%
 
OR33.0%
 
MI33.0%
 
NH33.0%
 
SD33.0%
 
TX33.0%
 
MT33.0%
 
WY33.0%
 
Other values (37)6767.0%
 

Length

Max length2
Median length2
Mean length2
Min length2

LAST_UPDATED_DATE
Date

CONSTANT
REJECTED

Distinct count1
Unique (%)1.0%
Missing0
Missing (%)0.0%
Memory size800.0 B
Minimum2020-08-07 12:04:04.675800
Maximum2020-08-07 12:04:04.675800
Histogram

LAST_REPORTED_FLAG
Boolean

CONSTANT
REJECTED

Distinct count1
Unique (%)1.0%
Missing0
Missing (%)0.0%
Memory size100.0 B
False
100
ValueCountFrequency (%) 
False100100.0%
 

HOSPITALIZEDCURRENTLY
Real number (ℝ≥0)

HIGH CORRELATION
MISSING

Distinct count71
Unique (%)98.6%
Missing28
Missing (%)28.0%
Infinite0
Infinite (%)0.0%
Mean1082.9583333333333
Minimum2.0
Maximum7226.0
Zeros0
Zeros (%)0.0%
Memory size800.0 B

Quantile statistics

Minimum2
5-th percentile13.1
Q1123.75
median449
Q31427.5
95-th percentile4604.55
Maximum7226
Range7224
Interquartile range (IQR)1303.75

Descriptive statistics

Standard deviation1535.146058
Coefficient of variation (CV)1.41754859
Kurtosis4.315520849
Mean1082.958333
Median Absolute Deviation (MAD)392
Skewness2.134122455
Sum77973
Variance2356673.421
Histogram with fixed size bins (bins=10)
ValueCountFrequency (%) 
5522.0%
 
722611.0%
 
32511.0%
 
68211.0%
 
98311.0%
 
23011.0%
 
39011.0%
 
12711.0%
 
76611.0%
 
98811.0%
 
Other values (61)6161.0%
 
(Missing)2828.0%
 
ValueCountFrequency (%) 
211.0%
 
411.0%
 
611.0%
 
1211.0%
 
1411.0%
 
ValueCountFrequency (%) 
722611.0%
 
552211.0%
 
532811.0%
 
462611.0%
 
458711.0%
 

HOSPITALIZEDCURRENTLYINCREASE
Real number (ℝ)

MISSING
ZEROS

Distinct count48
Unique (%)66.7%
Missing28
Missing (%)28.0%
Infinite0
Infinite (%)0.0%
Mean7.763888888888889
Minimum-589.0
Maximum482.0
Zeros7
Zeros (%)7.0%
Memory size800.0 B

Quantile statistics

Minimum-589
5-th percentile-86.9
Q1-5
median1.5
Q317.25
95-th percentile181
Maximum482
Range1071
Interquartile range (IQR)22.25

Descriptive statistics

Standard deviation125.6863403
Coefficient of variation (CV)16.18858051
Kurtosis10.84394672
Mean7.763888889
Median Absolute Deviation (MAD)13
Skewness-1.077087314
Sum559
Variance15797.05614
Histogram with fixed size bins (bins=10)
ValueCountFrequency (%) 
077.0%
 
-155.0%
 
-344.0%
 
233.0%
 
-3622.0%
 
422.0%
 
-522.0%
 
1522.0%
 
18122.0%
 
522.0%
 
Other values (38)4141.0%
 
(Missing)2828.0%
 
ValueCountFrequency (%) 
-58911.0%
 
-42011.0%
 
-23411.0%
 
-12111.0%
 
-5911.0%
 
ValueCountFrequency (%) 
48211.0%
 
30711.0%
 
23311.0%
 
18122.0%
 
12311.0%
 

HOSPITALIZEDCUMULATIVE
Real number (ℝ≥0)

HIGH CORRELATION
MISSING

Distinct count55
Unique (%)100.0%
Missing45
Missing (%)45.0%
Infinite0
Infinite (%)0.0%
Mean5433.8
Minimum1.0
Maximum84194.0
Zeros0
Zeros (%)0.0%
Memory size800.0 B

Quantile statistics

Minimum1
5-th percentile81
Q1606.5
median1644
Q36325
95-th percentile14846.5
Maximum84194
Range84193
Interquartile range (IQR)5718.5

Descriptive statistics

Standard deviation11887.22775
Coefficient of variation (CV)2.187645433
Kurtosis36.8452185
Mean5433.8
Median Absolute Deviation (MAD)1496
Skewness5.645648555
Sum298859
Variance141306183.7
Histogram with fixed size bins (bins=10)
ValueCountFrequency (%) 
872711.0%
 
1105111.0%
 
22611.0%
 
508011.0%
 
170011.0%
 
6711.0%
 
9311.0%
 
21611.0%
 
164411.0%
 
1198611.0%
 
Other values (45)4545.0%
 
(Missing)4545.0%
 
ValueCountFrequency (%) 
111.0%
 
1911.0%
 
6711.0%
 
8711.0%
 
9311.0%
 
ValueCountFrequency (%) 
8419411.0%
 
2106411.0%
 
2023311.0%
 
1253811.0%
 
1198611.0%
 

HOSPITALIZEDCUMULATIVEINCREASE
Real number (ℝ≥0)

HIGH CORRELATION
MISSING
ZEROS

Distinct count39
Unique (%)70.9%
Missing45
Missing (%)45.0%
Infinite0
Infinite (%)0.0%
Mean53.50909090909091
Minimum0.0
Maximum433.0
Zeros9
Zeros (%)9.0%
Memory size800.0 B

Quantile statistics

Minimum0
5-th percentile0
Q13
median23
Q361
95-th percentile184.5
Maximum433
Range433
Interquartile range (IQR)58

Descriptive statistics

Standard deviation76.9804864
Coefficient of variation (CV)1.438643137
Kurtosis10.29746183
Mean53.50909091
Median Absolute Deviation (MAD)23
Skewness2.769382348
Sum2943
Variance5925.995286
Histogram with fixed size bins (bins=10)
ValueCountFrequency (%) 
099.0%
 
5433.0%
 
222.0%
 
2022.0%
 
1322.0%
 
122.0%
 
322.0%
 
3622.0%
 
13311.0%
 
1011.0%
 
Other values (29)2929.0%
 
(Missing)4545.0%
 
ValueCountFrequency (%) 
099.0%
 
122.0%
 
222.0%
 
322.0%
 
411.0%
 
ValueCountFrequency (%) 
43311.0%
 
22711.0%
 
20211.0%
 
17711.0%
 
15811.0%
 

INICUCURRENTLY
Real number (ℝ≥0)

HIGH CORRELATION
MISSING

Distinct count38
Unique (%)92.7%
Missing59
Missing (%)59.0%
Infinite0
Infinite (%)0.0%
Mean436.8292682926829
Minimum2.0
Maximum2450.0
Zeros0
Zeros (%)0.0%
Memory size800.0 B

Quantile statistics

Minimum2
5-th percentile4
Q138
median174
Q3598
95-th percentile1523
Maximum2450
Range2448
Interquartile range (IQR)560

Descriptive statistics

Standard deviation573.4705268
Coefficient of variation (CV)1.312802434
Kurtosis2.638853783
Mean436.8292683
Median Absolute Deviation (MAD)161
Skewness1.700454643
Sum17910
Variance328868.4451
Histogram with fixed size bins (bins=10)
ValueCountFrequency (%) 
922.0%
 
222.0%
 
1322.0%
 
152311.0%
 
23111.0%
 
3811.0%
 
6711.0%
 
8111.0%
 
59811.0%
 
17411.0%
 
Other values (28)2828.0%
 
(Missing)5959.0%
 
ValueCountFrequency (%) 
222.0%
 
411.0%
 
922.0%
 
1211.0%
 
1322.0%
 
ValueCountFrequency (%) 
245011.0%
 
153411.0%
 
152311.0%
 
132911.0%
 
131211.0%
 

INICUCURRENTLYINCREASE
Real number (ℝ)

MISSING
ZEROS

Distinct count27
Unique (%)67.5%
Missing60
Missing (%)60.0%
Infinite0
Infinite (%)0.0%
Mean0.025
Minimum-76.0
Maximum42.0
Zeros7
Zeros (%)7.0%
Memory size800.0 B

Quantile statistics

Minimum-76
5-th percentile-38.3
Q1-5
median0
Q310.25
95-th percentile31.25
Maximum42
Range118
Interquartile range (IQR)15.25

Descriptive statistics

Standard deviation21.8168219
Coefficient of variation (CV)872.6728761
Kurtosis3.144090629
Mean0.025
Median Absolute Deviation (MAD)7.5
Skewness-1.05633309
Sum1
Variance475.9737179
Histogram with fixed size bins (bins=10)
ValueCountFrequency (%) 
077.0%
 
244.0%
 
-333.0%
 
-1122.0%
 
-522.0%
 
1111.0%
 
3611.0%
 
2811.0%
 
-3311.0%
 
-3811.0%
 
Other values (17)1717.0%
 
(Missing)6060.0%
 
ValueCountFrequency (%) 
-7611.0%
 
-4411.0%
 
-3811.0%
 
-3311.0%
 
-2111.0%
 
ValueCountFrequency (%) 
4211.0%
 
3611.0%
 
3111.0%
 
3011.0%
 
2811.0%
 

INICUCUMULATIVE
Real number (ℝ≥0)

HIGH CORRELATION
MISSING

Distinct count11
Unique (%)100.0%
Missing89
Missing (%)89.0%
Infinite0
Infinite (%)0.0%
Mean887.5454545454545
Minimum101.0
Maximum2323.0
Zeros0
Zeros (%)0.0%
Memory size800.0 B

Quantile statistics

Minimum101
5-th percentile127.5
Q1256.5
median483
Q31575
95-th percentile2079.5
Maximum2323
Range2222
Interquartile range (IQR)1318.5

Descriptive statistics

Standard deviation799.3893124
Coefficient of variation (CV)0.9006742227
Kurtosis-1.050966567
Mean887.5454545
Median Absolute Deviation (MAD)329
Skewness0.753947867
Sum9763
Variance639023.2727
Histogram with fixed size bins (bins=10)
ValueCountFrequency (%) 
232311.0%
 
132511.0%
 
182511.0%
 
15411.0%
 
183611.0%
 
48311.0%
 
40511.0%
 
79811.0%
 
22311.0%
 
29011.0%
 
(Missing)8989.0%
 
ValueCountFrequency (%) 
10111.0%
 
15411.0%
 
22311.0%
 
29011.0%
 
40511.0%
 
ValueCountFrequency (%) 
232311.0%
 
183611.0%
 
182511.0%
 
132511.0%
 
79811.0%
 

INICUCUMULATIVEINCREASE
Real number (ℝ≥0)

HIGH CORRELATION
MISSING
ZEROS

Distinct count9
Unique (%)81.8%
Missing89
Missing (%)89.0%
Infinite0
Infinite (%)0.0%
Mean12.0
Minimum0.0
Maximum34.0
Zeros2
Zeros (%)2.0%
Memory size800.0 B

Quantile statistics

Minimum0
5-th percentile0
Q13.5
median6
Q317.5
95-th percentile33.5
Maximum34
Range34
Interquartile range (IQR)14

Descriptive statistics

Standard deviation12.23110788
Coefficient of variation (CV)1.01925899
Kurtosis-0.1762543253
Mean12
Median Absolute Deviation (MAD)6
Skewness1.003147708
Sum132
Variance149.6
Histogram with fixed size bins (bins=10)
ValueCountFrequency (%) 
622.0%
 
022.0%
 
211.0%
 
511.0%
 
1711.0%
 
1111.0%
 
1811.0%
 
3311.0%
 
3411.0%
 
(Missing)8989.0%
 
ValueCountFrequency (%) 
022.0%
 
211.0%
 
511.0%
 
622.0%
 
1111.0%
 
ValueCountFrequency (%) 
3411.0%
 
3311.0%
 
1811.0%
 
1711.0%
 
1111.0%
 

ONVENTILATORCURRENTLY
Real number (ℝ≥0)

HIGH CORRELATION
MISSING

Distinct count33
Unique (%)91.7%
Missing64
Missing (%)64.0%
Infinite0
Infinite (%)0.0%
Mean230.30555555555554
Minimum2.0
Maximum2020.0
Zeros0
Zeros (%)0.0%
Memory size800.0 B

Quantile statistics

Minimum2
5-th percentile5.5
Q129.75
median81
Q3189.5
95-th percentile1016
Maximum2020
Range2018
Interquartile range (IQR)159.75

Descriptive statistics

Standard deviation412.5396479
Coefficient of variation (CV)1.791270935
Kurtosis10.14691888
Mean230.3055556
Median Absolute Deviation (MAD)62.5
Skewness3.022249252
Sum8291
Variance170188.9611
Histogram with fixed size bins (bins=10)
ValueCountFrequency (%) 
9922.0%
 
8122.0%
 
622.0%
 
202011.0%
 
13611.0%
 
3511.0%
 
4311.0%
 
4511.0%
 
73011.0%
 
9611.0%
 
Other values (23)2323.0%
 
(Missing)6464.0%
 
ValueCountFrequency (%) 
211.0%
 
411.0%
 
622.0%
 
711.0%
 
1111.0%
 
ValueCountFrequency (%) 
202011.0%
 
116911.0%
 
96511.0%
 
73011.0%
 
67111.0%
 

ONVENTILATORCURRENTLYINCREASE
Real number (ℝ)

MISSING
ZEROS

Distinct count20
Unique (%)55.6%
Missing64
Missing (%)64.0%
Infinite0
Infinite (%)0.0%
Mean-4.166666666666667
Minimum-62.0
Maximum40.0
Zeros8
Zeros (%)8.0%
Memory size800.0 B

Quantile statistics

Minimum-62
5-th percentile-33.5
Q1-7.25
median0
Q32.5
95-th percentile12.75
Maximum40
Range102
Interquartile range (IQR)9.75

Descriptive statistics

Standard deviation17.37239189
Coefficient of variation (CV)-4.169374054
Kurtosis4.700234208
Mean-4.166666667
Median Absolute Deviation (MAD)4.5
Skewness-1.332863063
Sum-150
Variance301.8
Histogram with fixed size bins (bins=10)
ValueCountFrequency (%) 
088.0%
 
-2033.0%
 
133.0%
 
422.0%
 
-322.0%
 
-822.0%
 
522.0%
 
722.0%
 
-111.0%
 
-511.0%
 
Other values (10)1010.0%
 
(Missing)6464.0%
 
ValueCountFrequency (%) 
-6211.0%
 
-5311.0%
 
-2711.0%
 
-2033.0%
 
-1511.0%
 
ValueCountFrequency (%) 
4011.0%
 
1511.0%
 
1211.0%
 
722.0%
 
522.0%
 

ONVENTILATORCUMULATIVE
Real number (ℝ≥0)

HIGH CORRELATION
MISSING

Distinct count6
Unique (%)100.0%
Missing94
Missing (%)94.0%
Infinite0
Infinite (%)0.0%
Mean146.16666666666666
Minimum94.0
Maximum174.0
Zeros0
Zeros (%)0.0%
Memory size800.0 B

Quantile statistics

Minimum94
5-th percentile102.25
Q1134.5
median158.5
Q3163.75
95-th percentile171.75
Maximum174
Range80
Interquartile range (IQR)29.25

Descriptive statistics

Standard deviation30.0893115
Coefficient of variation (CV)0.205856179
Kurtosis0.8526698983
Mean146.1666667
Median Absolute Deviation (MAD)11
Skewness-1.286745243
Sum877
Variance905.3666667
Histogram with fixed size bins (bins=10)
ValueCountFrequency (%) 
15711.0%
 
17411.0%
 
16011.0%
 
9411.0%
 
12711.0%
 
16511.0%
 
(Missing)9494.0%
 
ValueCountFrequency (%) 
9411.0%
 
12711.0%
 
15711.0%
 
16011.0%
 
16511.0%
 
ValueCountFrequency (%) 
17411.0%
 
16511.0%
 
16011.0%
 
15711.0%
 
12711.0%
 

ONVENTILATORCUMULATIVEINCREASE
Real number (ℝ≥0)

MISSING

Distinct count5
Unique (%)83.3%
Missing94
Missing (%)94.0%
Infinite0
Infinite (%)0.0%
Mean3.3333333333333335
Minimum0.0
Maximum7.0
Zeros1
Zeros (%)1.0%
Memory size800.0 B

Quantile statistics

Minimum0
5-th percentile0.5
Q12.25
median3
Q34.5
95-th percentile6.5
Maximum7
Range7
Interquartile range (IQR)2.25

Descriptive statistics

Standard deviation2.422120283
Coefficient of variation (CV)0.726636085
Kurtosis0.1588326446
Mean3.333333333
Median Absolute Deviation (MAD)1.5
Skewness0.304954452
Sum20
Variance5.866666667
Histogram with fixed size bins (bins=10)
ValueCountFrequency (%) 
322.0%
 
711.0%
 
011.0%
 
511.0%
 
211.0%
 
(Missing)9494.0%
 
ValueCountFrequency (%) 
011.0%
 
211.0%
 
322.0%
 
511.0%
 
711.0%
 
ValueCountFrequency (%) 
711.0%
 
511.0%
 
322.0%
 
211.0%
 
011.0%
 

Interactions

Correlations

Pearson's r

The Pearson's correlation coefficient (r) is a measure of linear correlation between two variables. It's value lies between -1 and +1, -1 indicating total negative linear correlation, 0 indicating no linear correlation and 1 indicating total positive linear correlation. Furthermore, r is invariant under separate changes in location and scale of the two variables, implying that for a linear function the angle to the x-axis does not affect r.

To calculate r for two variables X and Y, one divides the covariance of X and Y by the product of their standard deviations.

Missing values

Sample

First rows

COUNTRY_REGIONPROVINCE_STATEDATEPOSITIVEPOSITIVE_SINCE_PREVIOUS_DAYNEGATIVENEGATIVE_SINCE_PREVIOUS_DAYPENDINGPENDING_SINCE_PREVIOUS_DAYDEATHDEATH_SINCE_PREVIOUS_DAYHOSPITALIZEDHOSPITALIZED_SINCE_PREVIOUS_DAYTOTALTOTAL_SINCE_PREVIOUS_DAYISO3166_1ISO3166_2LAST_UPDATED_DATELAST_REPORTED_FLAGHOSPITALIZEDCURRENTLYHOSPITALIZEDCURRENTLYINCREASEHOSPITALIZEDCUMULATIVEHOSPITALIZEDCUMULATIVEINCREASEINICUCURRENTLYINICUCURRENTLYINCREASEINICUCUMULATIVEINICUCUMULATIVEINCREASEONVENTILATORCURRENTLYONVENTILATORCURRENTLYINCREASEONVENTILATORCUMULATIVEONVENTILATORCUMULATIVEINCREASE
0United StatesNorth Carolina2020-05-23227251107306857.025251NaNNaN737.09NaN032958226358USNC2020-08-07 12:04:04.675800False589.021.0NaNNaNNaNNaNNaNNaNNaNNaNNaNNaN
1United StatesGuam2020-04-131330770.077NaNNaN5.00NaN090377USGU2020-08-07 12:04:04.675800False12.0-1.0NaNNaN2.00.0NaNNaN2.00.0NaNNaN
2United StatesOregon2020-07-1513081276298705.06054NaNNaN247.031290.0363117866330USOR2020-08-07 12:04:04.675800False207.0-28.01290.036.053.0-11.0NaNNaN30.0-5.0NaNNaN

Last rows

COUNTRY_REGIONPROVINCE_STATEDATEPOSITIVEPOSITIVE_SINCE_PREVIOUS_DAYNEGATIVENEGATIVE_SINCE_PREVIOUS_DAYPENDINGPENDING_SINCE_PREVIOUS_DAYDEATHDEATH_SINCE_PREVIOUS_DAYHOSPITALIZEDHOSPITALIZED_SINCE_PREVIOUS_DAYTOTALTOTAL_SINCE_PREVIOUS_DAYISO3166_1ISO3166_2LAST_UPDATED_DATELAST_REPORTED_FLAGHOSPITALIZEDCURRENTLYHOSPITALIZEDCURRENTLYINCREASEHOSPITALIZEDCUMULATIVEHOSPITALIZEDCUMULATIVEINCREASEINICUCURRENTLYINICUCURRENTLYINCREASEINICUCUMULATIVEINICUCUMULATIVEINCREASEONVENTILATORCURRENTLYONVENTILATORCURRENTLYINCREASEONVENTILATORCUMULATIVEONVENTILATORCUMULATIVEINCREASE
97United StatesPuerto Rico2020-03-21217143.02971.019.0NaN0NaN023536USPR2020-08-07 12:04:04.675800FalseNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaN
98United StatesNebraska2020-05-09783164135145.01923NaNNaN92.02NaN0429762564USNE2020-08-07 12:04:04.675800FalseNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaN
99United StatesSouth Dakota2020-07-0671054277198.0258NaNNaN97.00692.0184303300USSD2020-08-07 12:04:04.675800False59.00.0692.01.0NaNNaNNaNNaNNaNNaNNaNNaN